/*
 Navicat Premium Data Transfer

 Source Server         : treeRoot
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : mybatis_plus

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 18/09/2022 23:05:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` bigint NOT NULL COMMENT '主键ID',
  `name` varchar(30) DEFAULT NULL COMMENT '姓名',
  `age` int DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `version` int DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'Sandy', 200, 'test4@baomidou.com', NULL, '2022-09-18 23:02:43', NULL, 0);
INSERT INTO `user` VALUES (2, 'Billie', 24, 'test5@baomidou.com', NULL, NULL, NULL, 0);
INSERT INTO `user` VALUES (3, '岳不群', 70, 'yuebuqun@qq.com', '2022-03-02 14:48:58', '2022-03-02 14:48:58', 1, 0);
INSERT INTO `user` VALUES (4, '东方不败', 200, 'dongfang@qq.com', '2022-03-02 14:59:51', '2022-03-02 14:59:51', 1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
